Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 157 |
| Missing cells | 51 |
| Missing cells (%) | 2.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 54.3 KiB |
| Average record size in memory | 354.5 B |
Variable types
| NUM | 12 |
|---|---|
| CAT | 4 |
Reproduction
| Analysis started | 2020-05-12 06:38:48.939151 |
|---|---|
| Analysis finished | 2020-05-12 06:39:39.864707 |
| Duration | 50.93 seconds |
| Version | pandas-profiling v2.7.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Model has a high cardinality: 156 distinct values | High cardinality |
Latest_Launch has a high cardinality: 130 distinct values | High cardinality |
Price_in_thousands is highly correlated with four_year_resale_value | High correlation |
four_year_resale_value is highly correlated with Price_in_thousands | High correlation |
Power_perf_factor is highly correlated with Horsepower | High correlation |
Horsepower is highly correlated with Power_perf_factor | High correlation |
four_year_resale_value has 36 (22.9%) missing values | Missing |
Price_in_thousands has 2 (1.3%) missing values | Missing |
Curb_weight has 2 (1.3%) missing values | Missing |
Fuel_efficiency has 3 (1.9%) missing values | Missing |
Power_perf_factor has 2 (1.3%) missing values | Missing |
Model is uniformly distributed | Uniform |
Latest_Launch is uniformly distributed | Uniform |
Sales_in_thousands has unique values | Unique |
Manufacturer
Categorical
| Distinct count | 30 |
|---|---|
| Unique (%) | 19.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 KiB |
| Ford | 11 |
|---|---|
| Dodge | 11 |
| Mercedes-B | 9 |
| Toyota | 9 |
| Chevrolet | 9 |
| Other values (25) |
| Value | Count | Frequency (%) | |
| Ford | 11 | 7.0% | |
| Dodge | 11 | 7.0% | |
| Mercedes-B | 9 | 5.7% | |
| Toyota | 9 | 5.7% | |
| Chevrolet | 9 | 5.7% | |
| Mitsubishi | 7 | 4.5% | |
| Chrysler | 7 | 4.5% | |
| Nissan | 7 | 4.5% | |
| Volkswagen | 6 | 3.8% | |
| Pontiac | 6 | 3.8% | |
| Other values (20) | 75 | 47.8% |
Length
| Max length | 10 |
|---|---|
| Mean length | 6.707006369 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 23 | 56.1% | |
| Uppercase_Letter | 17 | 41.5% | |
| Dash_Punctuation | 1 | 2.4% |
| Value | Count | Frequency (%) | |
| Latin | 40 | 97.6% | |
| Common | 1 | 2.4% |
| Value | Count | Frequency (%) | |
| ASCII | 41 | 100.0% |
| Distinct count | 156 |
|---|---|
| Unique (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 KiB |
| Neon | 2 |
|---|---|
| Ram Van | 1 |
| RAV4 | 1 |
| Xterra | 1 |
| 5-Sep | 1 |
| Other values (151) |
| Value | Count | Frequency (%) | |
| Neon | 2 | 1.3% | |
| Ram Van | 1 | 0.6% | |
| RAV4 | 1 | 0.6% | |
| Xterra | 1 | 0.6% | |
| 5-Sep | 1 | 0.6% | |
| Sonata | 1 | 0.6% | |
| Breeze | 1 | 0.6% | |
| Ram Pickup | 1 | 0.6% | |
| Cutlass | 1 | 0.6% | |
| Park Avenue | 1 | 0.6% | |
| Other values (146) | 146 | 93.0% |
Length
| Max length | 14 |
|---|---|
| Mean length | 6.554140127 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 25 | 41.7% | |
| Uppercase_Letter | 23 | 38.3% | |
| Decimal_Number | 8 | 13.3% | |
| Other_Punctuation | 2 | 3.3% | |
| Space_Separator | 1 | 1.7% | |
| Dash_Punctuation | 1 | 1.7% |
| Value | Count | Frequency (%) | |
| Latin | 48 | 80.0% | |
| Common | 12 | 20.0% |
| Value | Count | Frequency (%) | |
| ASCII | 60 | 100.0% |
| Distinct count | 157 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52.99807643312102 |
|---|---|
| Minimum | 0.11 |
| Maximum | 540.561 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 0.11 |
|---|---|
| 5-th percentile | 1.8708 |
| Q1 | 14.114 |
| median | 29.45 |
| Q3 | 67.956 |
| 95-th percentile | 185.3362 |
| Maximum | 540.561 |
| Range | 540.451 |
| Interquartile range (IQR) | 53.842 |
Descriptive statistics
| Standard deviation | 68.029422 |
|---|---|
| Coefficient of variation (CV) | 1.283620587 |
| Kurtosis | 17.55734423 |
| Mean | 52.99807643 |
| Median Absolute Deviation (MAD) | 20.468 |
| Skewness | 3.408518366 |
| Sum | 8320.698 |
| Variance | 4628.002257 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 63.729 | 1 | 0.6% | |
| 38.554 | 1 | 0.6% | |
| 33.269 | 1 | 0.6% | |
| 16.774 | 1 | 0.6% | |
| 8.472 | 1 | 0.6% | |
| 11.592 | 1 | 0.6% | |
| 48.911 | 1 | 0.6% | |
| 0.11 | 1 | 0.6% | |
| 54.158 | 1 | 0.6% | |
| 39.572 | 1 | 0.6% | |
| Other values (147) | 147 | 93.6% |
| Value | Count | Frequency (%) | |
| 0.11 | 1 | 0.6% | |
| 0.916 | 1 | 0.6% | |
| 0.954 | 1 | 0.6% | |
| 1.112 | 1 | 0.6% | |
| 1.28 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 540.561 | 1 | 0.6% | |
| 276.747 | 1 | 0.6% | |
| 247.994 | 1 | 0.6% | |
| 245.815 | 1 | 0.6% | |
| 230.902 | 1 | 0.6% |
| Distinct count | 117 |
|---|---|
| Unique (%) | 96.7% |
| Missing | 36 |
| Missing (%) | 22.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.07297520661157 |
|---|---|
| Minimum | 5.16 |
| Maximum | 67.55 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 5.16 |
|---|---|
| 5-th percentile | 7.85 |
| Q1 | 11.26 |
| median | 14.18 |
| Q3 | 19.875 |
| 95-th percentile | 41.25 |
| Maximum | 67.55 |
| Range | 62.39 |
| Interquartile range (IQR) | 8.615 |
Descriptive statistics
| Standard deviation | 11.4533841 |
|---|---|
| Coefficient of variation (CV) | 0.6337298629 |
| Kurtosis | 5.763855916 |
| Mean | 18.07297521 |
| Median Absolute Deviation (MAD) | 3.96 |
| Skewness | 2.294915493 |
| Sum | 2186.83 |
| Variance | 131.1800073 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 12.025 | 2 | 1.3% | |
| 7.75 | 2 | 1.3% | |
| 18.225 | 2 | 1.3% | |
| 16.575 | 2 | 1.3% | |
| 13.245 | 1 | 0.6% | |
| 14.01 | 1 | 0.6% | |
| 58.6 | 1 | 0.6% | |
| 22.255 | 1 | 0.6% | |
| 12.545 | 1 | 0.6% | |
| 10.31 | 1 | 0.6% | |
| Other values (107) | 107 | 68.2% | |
| (Missing) | 36 | 22.9% |
| Value | Count | Frequency (%) | |
| 5.16 | 1 | 0.6% | |
| 5.86 | 1 | 0.6% | |
| 7.425 | 1 | 0.6% | |
| 7.75 | 2 | 1.3% | |
| 7.825 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 67.55 | 1 | 0.6% | |
| 60.625 | 1 | 0.6% | |
| 58.6 | 1 | 0.6% | |
| 58.47 | 1 | 0.6% | |
| 50.375 | 1 | 0.6% |
Vehicle_type
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 KiB |
| Passenger | |
|---|---|
| Car |
| Value | Count | Frequency (%) | |
| Passenger | 116 | 73.9% | |
| Car | 41 | 26.1% |
Length
| Max length | 9 |
|---|---|
| Mean length | 7.433121019 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 6 | 75.0% | |
| Uppercase_Letter | 2 | 25.0% |
| Value | Count | Frequency (%) | |
| Latin | 8 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 8 | 100.0% |
| Distinct count | 152 |
|---|---|
| Unique (%) | 98.1% |
| Missing | 2 |
| Missing (%) | 1.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.390754838709682 |
|---|---|
| Minimum | 9.235 |
| Maximum | 85.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 9.235 |
|---|---|
| 5-th percentile | 12.469 |
| Q1 | 18.0175 |
| median | 22.799 |
| Q3 | 31.9475 |
| 95-th percentile | 55.835 |
| Maximum | 85.5 |
| Range | 76.265 |
| Interquartile range (IQR) | 13.93 |
Descriptive statistics
| Standard deviation | 14.35165319 |
|---|---|
| Coefficient of variation (CV) | 0.5239597548 |
| Kurtosis | 3.63041233 |
| Mean | 27.39075484 |
| Median Absolute Deviation (MAD) | 6.099 |
| Skewness | 1.765734331 |
| Sum | 4245.567 |
| Variance | 205.9699493 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 18.89 | 2 | 1.3% | |
| 38.9 | 2 | 1.3% | |
| 12.64 | 2 | 1.3% | |
| 71.02 | 1 | 0.6% | |
| 24.495 | 1 | 0.6% | |
| 31.965 | 1 | 0.6% | |
| 26.399 | 1 | 0.6% | |
| 31.505 | 1 | 0.6% | |
| 22.51 | 1 | 0.6% | |
| 28.8 | 1 | 0.6% | |
| Other values (142) | 142 | 90.4% | |
| (Missing) | 2 | 1.3% |
| Value | Count | Frequency (%) | |
| 9.235 | 1 | 0.6% | |
| 9.699 | 1 | 0.6% | |
| 10.685 | 1 | 0.6% | |
| 11.528 | 1 | 0.6% | |
| 11.799 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 85.5 | 1 | 0.6% | |
| 82.6 | 1 | 0.6% | |
| 74.97 | 1 | 0.6% | |
| 71.02 | 1 | 0.6% | |
| 69.725 | 1 | 0.6% |
Engine_size
Real number (ℝ≥0)
| Distinct count | 31 |
|---|---|
| Unique (%) | 19.9% |
| Missing | 1 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.0608974358974357 |
|---|---|
| Minimum | 1.0 |
| Maximum | 8.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1.8 |
| Q1 | 2.3 |
| median | 3 |
| Q3 | 3.575 |
| 95-th percentile | 4.775 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 1.275 |
Descriptive statistics
| Standard deviation | 1.044652973 |
|---|---|
| Coefficient of variation (CV) | 0.3412897672 |
| Kurtosis | 2.344782023 |
| Mean | 3.060897436 |
| Median Absolute Deviation (MAD) | 0.7 |
| Skewness | 1.100447343 |
| Sum | 477.5 |
| Variance | 1.091299835 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2 | 17 | 10.8% | |
| 3 | 14 | 8.9% | |
| 2.5 | 11 | 7.0% | |
| 2.4 | 11 | 7.0% | |
| 4.6 | 9 | 5.7% | |
| 3.5 | 8 | 5.1% | |
| 3.8 | 8 | 5.1% | |
| 1.8 | 8 | 5.1% | |
| 4 | 7 | 4.5% | |
| 3.4 | 7 | 4.5% | |
| Other values (21) | 56 | 35.7% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.6% | |
| 1.5 | 1 | 0.6% | |
| 1.6 | 1 | 0.6% | |
| 1.8 | 8 | 5.1% | |
| 1.9 | 5 | 3.2% |
| Value | Count | Frequency (%) | |
| 8 | 1 | 0.6% | |
| 5.7 | 2 | 1.3% | |
| 5.4 | 1 | 0.6% | |
| 5.2 | 2 | 1.3% | |
| 5 | 2 | 1.3% |
| Distinct count | 66 |
|---|---|
| Unique (%) | 42.3% |
| Missing | 1 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 185.94871794871796 |
|---|---|
| Minimum | 55.0 |
| Maximum | 450.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 55 |
|---|---|
| 5-th percentile | 114.5 |
| Q1 | 149.5 |
| median | 177.5 |
| Q3 | 215 |
| 95-th percentile | 300 |
| Maximum | 450 |
| Range | 395 |
| Interquartile range (IQR) | 65.5 |
Descriptive statistics
| Standard deviation | 56.70032086 |
|---|---|
| Coefficient of variation (CV) | 0.3049245054 |
| Kurtosis | 2.406657478 |
| Mean | 185.9487179 |
| Median Absolute Deviation (MAD) | 32.5 |
| Skewness | 1.000694992 |
| Sum | 29008 |
| Variance | 3214.926385 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 170 | 9 | 5.7% | |
| 150 | 9 | 5.7% | |
| 200 | 8 | 5.1% | |
| 210 | 7 | 4.5% | |
| 115 | 6 | 3.8% | |
| 275 | 5 | 3.2% | |
| 175 | 5 | 3.2% | |
| 185 | 5 | 3.2% | |
| 190 | 4 | 2.5% | |
| 120 | 4 | 2.5% | |
| Other values (56) | 94 | 59.9% |
| Value | Count | Frequency (%) | |
| 55 | 1 | 0.6% | |
| 92 | 1 | 0.6% | |
| 100 | 2 | 1.3% | |
| 106 | 1 | 0.6% | |
| 107 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 450 | 1 | 0.6% | |
| 345 | 1 | 0.6% | |
| 310 | 1 | 0.6% | |
| 302 | 2 | 1.3% | |
| 300 | 4 | 2.5% |
Wheelbase
Real number (ℝ≥0)
| Distinct count | 88 |
|---|---|
| Unique (%) | 56.4% |
| Missing | 1 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 107.48717948717949 |
|---|---|
| Minimum | 92.6 |
| Maximum | 138.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 92.6 |
|---|---|
| 5-th percentile | 95.875 |
| Q1 | 103 |
| median | 107 |
| Q3 | 112.2 |
| 95-th percentile | 119.25 |
| Maximum | 138.7 |
| Range | 46.1 |
| Interquartile range (IQR) | 9.2 |
Descriptive statistics
| Standard deviation | 7.64130303 |
|---|---|
| Coefficient of variation (CV) | 0.07109036693 |
| Kurtosis | 2.859284871 |
| Mean | 107.4871795 |
| Median Absolute Deviation (MAD) | 4.6 |
| Skewness | 0.9699356566 |
| Sum | 16768 |
| Variance | 58.38951199 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 112.2 | 8 | 5.1% | |
| 113 | 5 | 3.2% | |
| 107 | 5 | 3.2% | |
| 109 | 4 | 2.5% | |
| 98.9 | 4 | 2.5% | |
| 108 | 4 | 2.5% | |
| 102.4 | 4 | 2.5% | |
| 107.3 | 4 | 2.5% | |
| 106.5 | 4 | 2.5% | |
| 106.4 | 4 | 2.5% | |
| Other values (78) | 110 | 70.1% |
| Value | Count | Frequency (%) | |
| 92.6 | 2 | 1.3% | |
| 93.1 | 1 | 0.6% | |
| 93.4 | 1 | 0.6% | |
| 94.5 | 2 | 1.3% | |
| 94.9 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 138.7 | 1 | 0.6% | |
| 138.5 | 1 | 0.6% | |
| 131 | 1 | 0.6% | |
| 127.2 | 1 | 0.6% | |
| 121.5 | 1 | 0.6% |
Width
Real number (ℝ≥0)
| Distinct count | 78 |
|---|---|
| Unique (%) | 50.0% |
| Missing | 1 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 71.14999999999999 |
|---|---|
| Minimum | 62.6 |
| Maximum | 79.9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 62.6 |
|---|---|
| 5-th percentile | 66.5 |
| Q1 | 68.4 |
| median | 70.55 |
| Q3 | 73.425 |
| 95-th percentile | 78.2 |
| Maximum | 79.9 |
| Range | 17.3 |
| Interquartile range (IQR) | 5.025 |
Descriptive statistics
| Standard deviation | 3.451871862 |
|---|---|
| Coefficient of variation (CV) | 0.0485154162 |
| Kurtosis | -0.3004675291 |
| Mean | 71.15 |
| Median Absolute Deviation (MAD) | 2.4 |
| Skewness | 0.4838620694 |
| Sum | 11099.4 |
| Variance | 11.91541935 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 66.7 | 6 | 3.8% | |
| 74.4 | 6 | 3.8% | |
| 68.3 | 5 | 3.2% | |
| 70.3 | 5 | 3.2% | |
| 72.7 | 5 | 3.2% | |
| 69.1 | 4 | 2.5% | |
| 66.5 | 4 | 2.5% | |
| 69.4 | 4 | 2.5% | |
| 71.7 | 3 | 1.9% | |
| 73.6 | 3 | 1.9% | |
| Other values (68) | 111 | 70.7% |
| Value | Count | Frequency (%) | |
| 62.6 | 1 | 0.6% | |
| 65.7 | 1 | 0.6% | |
| 66.4 | 3 | 1.9% | |
| 66.5 | 4 | 2.5% | |
| 66.7 | 6 | 3.8% |
| Value | Count | Frequency (%) | |
| 79.9 | 1 | 0.6% | |
| 79.3 | 1 | 0.6% | |
| 79.1 | 1 | 0.6% | |
| 78.8 | 2 | 1.3% | |
| 78.7 | 1 | 0.6% |
Length
Real number (ℝ≥0)
| Distinct count | 127 |
|---|---|
| Unique (%) | 81.4% |
| Missing | 1 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 187.34358974358975 |
|---|---|
| Minimum | 149.4 |
| Maximum | 224.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 149.4 |
|---|---|
| 5-th percentile | 163.675 |
| Q1 | 177.575 |
| median | 187.9 |
| Q3 | 196.125 |
| 95-th percentile | 208.5 |
| Maximum | 224.5 |
| Range | 75.1 |
| Interquartile range (IQR) | 18.55 |
Descriptive statistics
| Standard deviation | 13.43175428 |
|---|---|
| Coefficient of variation (CV) | 0.07169583065 |
| Kurtosis | 0.3025740191 |
| Mean | 187.3435897 |
| Median Absolute Deviation (MAD) | 9.4 |
| Skewness | -0.05904682307 |
| Sum | 29225.6 |
| Variance | 180.4120232 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 186.3 | 4 | 2.5% | |
| 192 | 3 | 1.9% | |
| 189.2 | 3 | 1.9% | |
| 190.4 | 3 | 1.9% | |
| 176.9 | 2 | 1.3% | |
| 201.2 | 2 | 1.3% | |
| 194.8 | 2 | 1.3% | |
| 176.6 | 2 | 1.3% | |
| 163.3 | 2 | 1.3% | |
| 174.5 | 2 | 1.3% | |
| Other values (117) | 131 | 83.4% |
| Value | Count | Frequency (%) | |
| 149.4 | 1 | 0.6% | |
| 152 | 1 | 0.6% | |
| 157.3 | 1 | 0.6% | |
| 157.9 | 1 | 0.6% | |
| 160.4 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 224.5 | 1 | 0.6% | |
| 224.2 | 1 | 0.6% | |
| 215.3 | 1 | 0.6% | |
| 215 | 1 | 0.6% | |
| 212 | 2 | 1.3% |
| Distinct count | 147 |
|---|---|
| Unique (%) | 94.8% |
| Missing | 2 |
| Missing (%) | 1.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.378025806451613 |
|---|---|
| Minimum | 1.895 |
| Maximum | 5.572 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1.895 |
|---|---|
| 5-th percentile | 2.4235 |
| Q1 | 2.971 |
| median | 3.342 |
| Q3 | 3.7995 |
| 95-th percentile | 4.3891 |
| Maximum | 5.572 |
| Range | 3.677 |
| Interquartile range (IQR) | 0.8285 |
Descriptive statistics
| Standard deviation | 0.6305016344 |
|---|---|
| Coefficient of variation (CV) | 0.1866479626 |
| Kurtosis | 1.265453569 |
| Mean | 3.378025806 |
| Median Absolute Deviation (MAD) | 0.41 |
| Skewness | 0.7081582404 |
| Sum | 523.594 |
| Variance | 0.397532311 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2.998 | 3 | 1.9% | |
| 2.769 | 3 | 1.9% | |
| 3.876 | 2 | 1.3% | |
| 2.91 | 2 | 1.3% | |
| 3.075 | 2 | 1.3% | |
| 3.368 | 2 | 1.3% | |
| 2.567 | 1 | 0.6% | |
| 4.47 | 1 | 0.6% | |
| 2.398 | 1 | 0.6% | |
| 2.425 | 1 | 0.6% | |
| Other values (137) | 137 | 87.3% | |
| (Missing) | 2 | 1.3% |
| Value | Count | Frequency (%) | |
| 1.895 | 1 | 0.6% | |
| 2.24 | 1 | 0.6% | |
| 2.25 | 1 | 0.6% | |
| 2.332 | 1 | 0.6% | |
| 2.339 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 5.572 | 1 | 0.6% | |
| 5.401 | 1 | 0.6% | |
| 5.393 | 1 | 0.6% | |
| 5.115 | 1 | 0.6% | |
| 4.808 | 1 | 0.6% |
Fuel_capacity
Real number (ℝ≥0)
| Distinct count | 55 |
|---|---|
| Unique (%) | 35.3% |
| Missing | 1 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.951923076923077 |
|---|---|
| Minimum | 10.3 |
| Maximum | 32.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 10.3 |
|---|---|
| 5-th percentile | 12.5 |
| Q1 | 15.8 |
| median | 17.2 |
| Q3 | 19.575 |
| 95-th percentile | 25.4 |
| Maximum | 32 |
| Range | 21.7 |
| Interquartile range (IQR) | 3.775 |
Descriptive statistics
| Standard deviation | 3.887921265 |
|---|---|
| Coefficient of variation (CV) | 0.2165740822 |
| Kurtosis | 2.07281321 |
| Mean | 17.95192308 |
| Median Absolute Deviation (MAD) | 1.9 |
| Skewness | 1.136712406 |
| Sum | 2800.5 |
| Variance | 15.11593176 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 18.5 | 14 | 8.9% | |
| 17 | 9 | 5.7% | |
| 19 | 8 | 5.1% | |
| 20 | 8 | 5.1% | |
| 16 | 7 | 4.5% | |
| 13.2 | 6 | 3.8% | |
| 15.9 | 6 | 3.8% | |
| 17.5 | 5 | 3.2% | |
| 15 | 5 | 3.2% | |
| 14.5 | 5 | 3.2% | |
| Other values (45) | 83 | 52.9% |
| Value | Count | Frequency (%) | |
| 10.3 | 1 | 0.6% | |
| 11.9 | 2 | 1.3% | |
| 12 | 1 | 0.6% | |
| 12.1 | 3 | 1.9% | |
| 12.5 | 2 | 1.3% |
| Value | Count | Frequency (%) | |
| 32 | 2 | 1.3% | |
| 30 | 2 | 1.3% | |
| 26 | 3 | 1.9% | |
| 25.4 | 2 | 1.3% | |
| 25.1 | 1 | 0.6% |
| Distinct count | 20 |
|---|---|
| Unique (%) | 13.0% |
| Missing | 3 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.844155844155843 |
|---|---|
| Minimum | 15.0 |
| Maximum | 45.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 15 |
|---|---|
| 5-th percentile | 16.65 |
| Q1 | 21 |
| median | 24 |
| Q3 | 26 |
| 95-th percentile | 31 |
| Maximum | 45 |
| Range | 30 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 4.282705562 |
|---|---|
| Coefficient of variation (CV) | 0.1796123792 |
| Kurtosis | 3.241130815 |
| Mean | 23.84415584 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.6923277567 |
| Sum | 3672 |
| Variance | 18.34156693 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 25 | 23 | 14.6% | |
| 24 | 16 | 10.2% | |
| 27 | 15 | 9.6% | |
| 23 | 14 | 8.9% | |
| 22 | 14 | 8.9% | |
| 21 | 14 | 8.9% | |
| 26 | 12 | 7.6% | |
| 19 | 6 | 3.8% | |
| 20 | 5 | 3.2% | |
| 18 | 5 | 3.2% | |
| Other values (10) | 30 | 19.1% |
| Value | Count | Frequency (%) | |
| 15 | 5 | 3.2% | |
| 16 | 3 | 1.9% | |
| 17 | 3 | 1.9% | |
| 18 | 5 | 3.2% | |
| 19 | 6 | 3.8% |
| Value | Count | Frequency (%) | |
| 45 | 1 | 0.6% | |
| 33 | 4 | 2.5% | |
| 32 | 1 | 0.6% | |
| 31 | 3 | 1.9% | |
| 30 | 5 | 3.2% |
| Distinct count | 130 |
|---|---|
| Unique (%) | 82.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 KiB |
| 10/5/2012 | 2 |
|---|---|
| 8/27/2011 | 2 |
| 8/31/2011 | 2 |
| 11/14/2011 | 2 |
| 1/4/2012 | 2 |
| Other values (125) |
| Value | Count | Frequency (%) | |
| 10/5/2012 | 2 | 1.3% | |
| 8/27/2011 | 2 | 1.3% | |
| 8/31/2011 | 2 | 1.3% | |
| 11/14/2011 | 2 | 1.3% | |
| 1/4/2012 | 2 | 1.3% | |
| 4/1/2011 | 2 | 1.3% | |
| 9/25/2011 | 2 | 1.3% | |
| 11/24/2012 | 2 | 1.3% | |
| 6/27/2012 | 2 | 1.3% | |
| 4/11/2011 | 2 | 1.3% | |
| Other values (120) | 137 | 87.3% |
Length
| Max length | 10 |
|---|---|
| Mean length | 8.968152866 |
| Min length | 8 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 90.9% | |
| Other_Punctuation | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| Common | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
| Distinct count | 154 |
|---|---|
| Unique (%) | 99.4% |
| Missing | 2 |
| Missing (%) | 1.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 77.0435912007742 |
|---|---|
| Minimum | 23.27627233 |
| Maximum | 188.14432299999999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 23.27627233 |
|---|---|
| 5-th percentile | 46.2039974 |
| Q1 | 60.40770678 |
| median | 72.03091719 |
| Q3 | 89.41487752 |
| 95-th percentile | 125.0915129 |
| Maximum | 188.144323 |
| Range | 164.8680507 |
| Interquartile range (IQR) | 29.00717075 |
Descriptive statistics
| Standard deviation | 25.1426641 |
|---|---|
| Coefficient of variation (CV) | 0.3263433558 |
| Kurtosis | 2.081292892 |
| Mean | 77.0435912 |
| Median Absolute Deviation (MAD) | 14.24160572 |
| Skewness | 1.070634989 |
| Sum | 11941.75664 |
| Variance | 632.153558 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 52.08489875 | 2 | 1.3% | |
| 76.50918456 | 1 | 0.6% | |
| 90.21170005 | 1 | 0.6% | |
| 70.07832154 | 1 | 0.6% | |
| 62.44196235 | 1 | 0.6% | |
| 54.26954829 | 1 | 0.6% | |
| 106.9844563 | 1 | 0.6% | |
| 70.38973726 | 1 | 0.6% | |
| 80.65769646 | 1 | 0.6% | |
| 81.49272616 | 1 | 0.6% | |
| Other values (144) | 144 | 91.7% | |
| (Missing) | 2 | 1.3% |
| Value | Count | Frequency (%) | |
| 23.27627233 | 1 | 0.6% | |
| 36.67228358 | 1 | 0.6% | |
| 39.98642475 | 1 | 0.6% | |
| 40.70007242 | 1 | 0.6% | |
| 42.87909734 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 188.144323 | 1 | 0.6% | |
| 141.14115 | 1 | 0.6% | |
| 141.1009845 | 1 | 0.6% | |
| 139.9822936 | 1 | 0.6% | |
| 135.9147096 | 1 | 0.6% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Manufacturer | Model | Sales_in_thousands | four_year_resale_value | Vehicle_type | Price_in_thousands | Engine_size | Horsepower | Wheelbase | Width | Length | Curb_weight | Fuel_capacity | Fuel_efficiency | Latest_Launch | Power_perf_factor | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Acura | Integra | 16.919 | 16.360 | Passenger | 21.50 | 1.8 | 140.0 | 101.2 | 67.3 | 172.4 | 2.639 | 13.2 | 28.0 | 2/2/2012 | 58.280150 |
| 1 | Acura | TL | 39.384 | 19.875 | Passenger | 28.40 | 3.2 | 225.0 | 108.1 | 70.3 | 192.9 | 3.517 | 17.2 | 25.0 | 6/3/2011 | 91.370778 |
| 2 | Acura | CL | 14.114 | 18.225 | Passenger | NaN | 3.2 | 225.0 | 106.9 | 70.6 | 192.0 | 3.470 | 17.2 | 26.0 | 1/4/2012 | NaN |
| 3 | Acura | RL | 8.588 | 29.725 | Passenger | 42.00 | 3.5 | 210.0 | 114.6 | 71.4 | 196.6 | 3.850 | 18.0 | 22.0 | 3/10/2011 | 91.389779 |
| 4 | Audi | A4 | 20.397 | 22.255 | Passenger | 23.99 | 1.8 | 150.0 | 102.6 | 68.2 | 178.0 | 2.998 | 16.4 | 27.0 | 10/8/2011 | 62.777639 |
| 5 | Audi | A6 | 18.780 | 23.555 | Passenger | 33.95 | 2.8 | 200.0 | 108.7 | 76.1 | 192.0 | 3.561 | 18.5 | 22.0 | 8/9/2011 | 84.565105 |
| 6 | Audi | A8 | 1.380 | 39.000 | Passenger | 62.00 | 4.2 | 310.0 | 113.0 | 74.0 | 198.2 | 3.902 | 23.7 | 21.0 | 2/27/2012 | 134.656858 |
| 7 | BMW | 323i | 19.747 | NaN | Passenger | 26.99 | 2.5 | 170.0 | 107.3 | 68.4 | 176.0 | 3.179 | 16.6 | 26.0 | 6/28/2011 | 71.191207 |
| 8 | BMW | 328i | 9.231 | 28.675 | Passenger | 33.40 | 2.8 | 193.0 | 107.3 | 68.5 | 176.0 | 3.197 | 16.6 | 24.0 | 1/29/2012 | 81.877069 |
| 9 | BMW | 528i | 17.527 | 36.125 | Passenger | 38.90 | 2.8 | 193.0 | 111.4 | 70.9 | 188.0 | 3.472 | 18.5 | 25.0 | 4/4/2011 | 83.998724 |
Last rows
| Manufacturer | Model | Sales_in_thousands | four_year_resale_value | Vehicle_type | Price_in_thousands | Engine_size | Horsepower | Wheelbase | Width | Length | Curb_weight | Fuel_capacity | Fuel_efficiency | Latest_Launch | Power_perf_factor | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 147 | Volkswagen | Passat | 51.102 | 16.725 | Passenger | 21.20 | 1.8 | 150.0 | 106.4 | 68.5 | 184.1 | 3.043 | 16.4 | 27.0 | 10/30/2012 | 61.701381 |
| 148 | Volkswagen | Cabrio | 9.569 | 16.575 | Passenger | 19.99 | 2.0 | 115.0 | 97.4 | 66.7 | 160.4 | 3.079 | 13.7 | 26.0 | 5/31/2011 | 48.907372 |
| 149 | Volkswagen | GTI | 5.596 | 13.760 | Passenger | 17.50 | 2.0 | 115.0 | 98.9 | 68.3 | 163.3 | 2.762 | 14.6 | 26.0 | 4/1/2011 | 47.946841 |
| 150 | Volkswagen | Beetle | 49.463 | NaN | Passenger | 15.90 | 2.0 | 115.0 | 98.9 | 67.9 | 161.1 | 2.769 | 14.5 | 26.0 | 10/20/2011 | 47.329632 |
| 151 | Volvo | S40 | 16.957 | NaN | Passenger | 23.40 | 1.9 | 160.0 | 100.5 | 67.6 | 176.6 | 2.998 | 15.8 | 25.0 | 2/18/2011 | 66.113057 |
| 152 | Volvo | V40 | 3.545 | NaN | Passenger | 24.40 | 1.9 | 160.0 | 100.5 | 67.6 | 176.6 | 3.042 | 15.8 | 25.0 | 9/21/2011 | 66.498812 |
| 153 | Volvo | S70 | 15.245 | NaN | Passenger | 27.50 | 2.4 | 168.0 | 104.9 | 69.3 | 185.9 | 3.208 | 17.9 | 25.0 | 11/24/2012 | 70.654495 |
| 154 | Volvo | V70 | 17.531 | NaN | Passenger | 28.80 | 2.4 | 168.0 | 104.9 | 69.3 | 186.2 | 3.259 | 17.9 | 25.0 | 6/25/2011 | 71.155978 |
| 155 | Volvo | C70 | 3.493 | NaN | Passenger | 45.50 | 2.3 | 236.0 | 104.9 | 71.5 | 185.7 | 3.601 | 18.5 | 23.0 | 4/26/2011 | 101.623357 |
| 156 | Volvo | S80 | 18.969 | NaN | Passenger | 36.00 | 2.9 | 201.0 | 109.9 | 72.1 | 189.8 | 3.600 | 21.1 | 24.0 | 11/14/2011 | 85.735655 |